IF exists(SELECT * FROM dbo.sysobjects WHERE name='OudFoutief' AND xtype='V') 
BEGIN
	DROP VIEW OudFoutief
END
GO

create view OudFoutief
as
select * from oudresultaten 
where not(type like 'HOKT' or type like 'HOLT' or type like 'U') or type is null